/*
 * @Author: dailuyu
 * @Date: 2021-08-17 20:55:56
 * @Email: dly@hyrctec.com
 * @LastEditors: dailuyu
 * @LastEditTime: 2021-08-17 23:16:14
 * @Company: hyrc
 * @FilePath: \TaskErrorManageApi\database\Dao\users\users_sql.js
 * @Description:
 */
module.exports = {
  Login: "SELECT * FROM memberinfo WHERE LoginName = ? and Password = ?;",
  AddUser: "INSERT INTO memberinfo (Id, UserName, RoleId, LoginName, Password, Remark) VALUES (?, ?, ?, ?, ?, ?);",
  DeleteUser: "DELETE FROM memberinfo WHERE Id = ?;",
  QueryUser: "SELECT * FROM memberinfo WHERE Id = ?;",
}